package com.mapper;

import com.domain.vo.PriceTypeVo;
import com.domain.vo.ProductStatisticVo;
import com.domain.vo.ProductTop20Vo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.sql.Date;
import java.util.List;

@Mapper
public interface ReportMapper  {


    List<ProductStatisticVo> findTotalSalesVolumeByDateRange(@Param("startDate") Date startDate, @Param("endDate") Date endDate);

    List<PriceTypeVo> getPriceTypeCountByDateRange(@Param("startDate") Date startSqlDate, @Param("endDate") Date endSqlDate);

    List<ProductTop20Vo> getProductTop20ByDateRange(@Param("startDate") Date startSqlDate, @Param("endDate") Date endSqlDate);


}